Data Profiling Report After Initial Cleaning

Dataset statistics

Number of variables	28
Number of observations	1780807
Missing cells	125407
Missing cells (%)	0.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	275.1 MiB
Average record size in memory	162.0 B

Variable types

Categorical	10
Numeric	16
Text	1
DateTime	1

Alerts

`addr_state` has a high cardinality: 51 distinct values	High cardinality
`application_type` is highly imbalanced (76.5%)	Imbalance
`emp_title` has 125407 (7.0%) missing values	Missing
`annual_inc` is highly skewed (γ1 = 516.8210002)	Skewed
`dti` is highly skewed (γ1 = 29.73491815)	Skewed
`bc_util` has 23343 (1.3%) zeros	Zeros
`chargeoff_within_12_mths` has 1766309 (99.2%) zeros	Zeros
`delinq_2yrs` has 1438977 (80.8%) zeros	Zeros
`inq_last_6mths` has 1058418 (59.4%) zeros	Zeros
`last_fico_range_low` has 47732 (2.7%) zeros	Zeros

Reproduction

Analysis started	2024-07-08 04:33:21.373994
Analysis finished	2024-07-08 04:33:56.067517
Duration	34.69 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

addr_state
Categorical

HIGH CARDINALITY

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

CA	250934
TX	147053
NY	144022
FL	128052
IL	69826
Other values (46)	1040920

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	3561614
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	NC
2nd row	TX
3rd row	MI
4th row	TX
5th row	NC

Common Values

Value	Count	Frequency (%)
CA	250934	14.1%
TX	147053	8.3%
NY	144022	8.1%
FL	128052	7.2%
IL	69826	3.9%
NJ	63987	3.6%
PA	59851	3.4%
OH	58668	3.3%
GA	57985	3.3%
NC	49925	2.8%
Other values (41)	750504	42.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ca	250934	14.1%
tx	147053	8.3%
ny	144022	8.1%
fl	128052	7.2%
il	69826	3.9%
nj	63987	3.6%
pa	59851	3.4%
oh	58668	3.3%
ga	57985	3.3%
nc	49925	2.8%
Other values (41)	750504	42.1%

Most occurring characters

Value	Count	Frequency (%)
A	599499	16.8%
N	402601	11.3%
C	392331	11.0%
L	239692	6.7%
T	224180	6.3%
M	217183	6.1%
I	190625	5.4%
Y	165008	4.6%
O	163751	4.6%
X	147053	4.1%
Other values (14)	819691	23.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3561614	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	599499	16.8%
N	402601	11.3%
C	392331	11.0%
L	239692	6.7%
T	224180	6.3%
M	217183	6.1%
I	190625	5.4%
Y	165008	4.6%
O	163751	4.6%
X	147053	4.1%
Other values (14)	819691	23.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3561614	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	599499	16.8%
N	402601	11.3%
C	392331	11.0%
L	239692	6.7%
T	224180	6.3%
M	217183	6.1%
I	190625	5.4%
Y	165008	4.6%
O	163751	4.6%
X	147053	4.1%
Other values (14)	819691	23.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3561614	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	599499	16.8%
N	402601	11.3%
C	392331	11.0%
L	239692	6.7%
T	224180	6.3%
M	217183	6.1%
I	190625	5.4%
Y	165008	4.6%
O	163751	4.6%
X	147053	4.1%
Other values (14)	819691	23.0%

annual_inc
Real number (ℝ)

SKEWED

Distinct	76561
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	77885.389

Minimum	0
Maximum	1.1 × 10⁸
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	27.2 MiB

Quantile statistics

Minimum	0
5-th percentile	28000
Q1	46500
median	65000
Q3	93000
95-th percentile	160000
Maximum	1.1 × 10⁸
Range	1.1 × 10⁸
Interquartile range (IQR)	46500

Descriptive statistics

Standard deviation	119925.06
Coefficient of variation (CV)	1.5397632
Kurtosis	434392.92
Mean	77885.389
Median Absolute Deviation (MAD)	21676
Skewness	516.821
Sum	1.3869885 × 10¹¹
Variance	1.4382019 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60000	68747	3.9%
50000	60531	3.4%
65000	51887	2.9%
70000	49417	2.8%
80000	47332	2.7%
40000	46945	2.6%
75000	46307	2.6%
45000	43411	2.4%
55000	41296	2.3%
100000	36997	2.1%
Other values (76551)	1287937	72.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	< 0.1%
15	1	< 0.1%
16	1	< 0.1%
20	2	< 0.1%
23	1	< 0.1%
25	1	< 0.1%
32	1	< 0.1%
33	1	< 0.1%
39	1	< 0.1%
40	1	< 0.1%

Value	Count	Frequency (%)
110000000	1	< 0.1%
61000000	1	< 0.1%
10999200	1	< 0.1%
9573072	1	< 0.1%
9550000	1	< 0.1%
9522972	1	< 0.1%
9500000	1	< 0.1%
9300000	1	< 0.1%
9225000	1	< 0.1%
9100000	1	< 0.1%

application_type
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

Individual	1712446
Joint App	68361

Length

Max length	10
Median length	10
Mean length	9.9616123
Min length	9

Characters and Unicode

Total characters	17739709
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Individual
2nd row	Individual
3rd row	Individual
4th row	Individual
5th row	Individual

Common Values

Value	Count	Frequency (%)
Individual	1712446	96.2%
Joint App	68361	3.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
individual	1712446	92.6%
joint	68361	3.7%
app	68361	3.7%

Most occurring characters

Value	Count	Frequency (%)
i	3493253	19.7%
d	3424892	19.3%
n	1780807	10.0%
I	1712446	9.7%
v	1712446	9.7%
u	1712446	9.7%
a	1712446	9.7%
l	1712446	9.7%
p	136722	0.8%
J	68361	0.4%
Other values (4)	273444	1.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	17739709	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	3493253	19.7%
d	3424892	19.3%
n	1780807	10.0%
I	1712446	9.7%
v	1712446	9.7%
u	1712446	9.7%
a	1712446	9.7%
l	1712446	9.7%
p	136722	0.8%
J	68361	0.4%
Other values (4)	273444	1.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	17739709	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	3493253	19.7%
d	3424892	19.3%
n	1780807	10.0%
I	1712446	9.7%
v	1712446	9.7%
u	1712446	9.7%
a	1712446	9.7%
l	1712446	9.7%
p	136722	0.8%
J	68361	0.4%
Other values (4)	273444	1.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	17739709	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	3493253	19.7%
d	3424892	19.3%
n	1780807	10.0%
I	1712446	9.7%
v	1712446	9.7%
u	1712446	9.7%
a	1712446	9.7%
l	1712446	9.7%
p	136722	0.8%
J	68361	0.4%
Other values (4)	273444	1.5%

avg_cur_bal
Real number (ℝ)

Distinct	83440
Distinct (%)	4.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13478.885

Minimum	0
Maximum	555925
Zeros	614
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	27.2 MiB

Quantile statistics

Minimum	0
5-th percentile	1080
Q1	3083
median	7367
Q3	18738
95-th percentile	43186
Maximum	555925
Range	555925
Interquartile range (IQR)	15655

Descriptive statistics

Standard deviation	16169.577
Coefficient of variation (CV)	1.1996227
Kurtosis	28.74356
Mean	13478.885
Median Absolute Deviation (MAD)	5392
Skewness	3.4862601
Sum	2.4003294 × 10¹⁰
Variance	2.6145523 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	614	< 0.1%
1971	229	< 0.1%
2253	228	< 0.1%
2149	224	< 0.1%
2842	221	< 0.1%
2079	221	< 0.1%
2606	221	< 0.1%
2076	221	< 0.1%
2447	220	< 0.1%
2301	220	< 0.1%
Other values (83430)	1778188	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	614	< 0.1%
1	53	< 0.1%
2	46	< 0.1%
3	50	< 0.1%
4	26	< 0.1%
5	42	< 0.1%
6	38	< 0.1%
7	29	< 0.1%
8	30	< 0.1%
9	33	< 0.1%

Value	Count	Frequency (%)
555925	1	< 0.1%
502002	1	< 0.1%
498284	1	< 0.1%
497484	1	< 0.1%
478909	1	< 0.1%
477255	1	< 0.1%
466840	1	< 0.1%
463945	1	< 0.1%
463276	1	< 0.1%
447102	1	< 0.1%

bc_util
Real number (ℝ)

ZEROS

Distinct	1476
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	58.080035

Minimum	0
Maximum	339.6
Zeros	23343
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	27.2 MiB

Quantile statistics

Minimum	0
5-th percentile	7.4
Q1	35.5
median	60.6
Q3	83.4
95-th percentile	97.9
Maximum	339.6
Range	339.6
Interquartile range (IQR)	47.9

Descriptive statistics

Standard deviation	28.712832
Coefficient of variation (CV)	0.49436665
Kurtosis	-0.99516944
Mean	58.080035
Median Absolute Deviation (MAD)	23.8
Skewness	-0.28259824
Sum	1.0342933 × 10⁸
Variance	824.42673
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	23343	1.3%
98	4957	0.3%
97	4666	0.3%
99	4596	0.3%
96	4517	0.3%
95	4194	0.2%
94	3983	0.2%
93	3800	0.2%
92	3671	0.2%
91	3551	0.2%
Other values (1466)	1719529	96.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	23343	1.3%
0.1	1949	0.1%
0.2	1705	0.1%
0.3	1445	0.1%
0.4	1244	0.1%
0.5	1187	0.1%
0.6	1086	0.1%
0.7	1076	0.1%
0.8	1029	0.1%
0.9	970	0.1%

Value	Count	Frequency (%)
339.6	1	< 0.1%
318.2	1	< 0.1%
255.2	1	< 0.1%
252.3	1	< 0.1%
243.8	1	< 0.1%
235.3	1	< 0.1%
204.6	1	< 0.1%
202.9	1	< 0.1%
202	1	< 0.1%
201.9	1	< 0.1%

chargeoff_within_12_mths
Real number (ℝ)

ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0091183379

Minimum	0
Maximum	10
Zeros	1766309
Zeros (%)	99.2%
Negative	0
Negative (%)	0.0%
Memory size	27.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	10
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.10969887
Coefficient of variation (CV)	12.030577
Kurtosis	604.95495
Mean	0.0091183379
Median Absolute Deviation (MAD)	0
Skewness	18.073747
Sum	16238
Variance	0.012033841
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	1766309	99.2%
1	13249	0.7%
2	974	0.1%
3	165	< 0.1%
4	63	< 0.1%
5	20	< 0.1%
6	12	< 0.1%
7	6	< 0.1%
9	6	< 0.1%
8	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1766309	99.2%
1	13249	0.7%
2	974	0.1%
3	165	< 0.1%
4	63	< 0.1%
5	20	< 0.1%
6	12	< 0.1%
7	6	< 0.1%
8	2	< 0.1%
9	6	< 0.1%

Value	Count	Frequency (%)
10	1	< 0.1%
9	6	< 0.1%
8	2	< 0.1%
7	6	< 0.1%
6	12	< 0.1%
5	20	< 0.1%
4	63	< 0.1%
3	165	< 0.1%
2	974	0.1%
1	13249	0.7%

delinq_2yrs
Real number (ℝ)

ZEROS

Distinct	34
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.31743024

Minimum	0
Maximum	39
Zeros	1438977
Zeros (%)	80.8%
Negative	0
Negative (%)	0.0%
Memory size	27.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	39
Range	39
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.88197411
Coefficient of variation (CV)	2.7784817
Kurtosis	60.025758
Mean	0.31743024
Median Absolute Deviation (MAD)	0
Skewness	5.6693133
Sum	565282
Variance	0.77787833
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
0	1438977	80.8%
1	227186	12.8%
2	66195	3.7%
3	24223	1.4%
4	10833	0.6%
5	5451	0.3%
6	3102	0.2%
7	1712	0.1%
8	1044	0.1%
9	653	< 0.1%
Other values (24)	1431	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1438977	80.8%
1	227186	12.8%
2	66195	3.7%
3	24223	1.4%
4	10833	0.6%
5	5451	0.3%
6	3102	0.2%
7	1712	0.1%
8	1044	0.1%
9	653	< 0.1%

Value	Count	Frequency (%)
39	1	< 0.1%
36	1	< 0.1%
32	1	< 0.1%
30	1	< 0.1%
29	2	< 0.1%
28	1	< 0.1%
27	1	< 0.1%
26	3	< 0.1%
25	2	< 0.1%
24	1	< 0.1%

dti
Real number (ℝ)

SKEWED

Distinct	9349
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.746592

Minimum	-1
Maximum	999
Zeros	971
Zeros (%)	0.1%
Negative	2
Negative (%)	< 0.1%
Memory size	27.2 MiB

Quantile statistics

Minimum	-1
5-th percentile	5.07
Q1	11.96
median	17.88
Q3	24.52
95-th percentile	33.6
Maximum	999
Range	1000
Interquartile range (IQR)	12.56

Descriptive statistics

Standard deviation	13.228308
Coefficient of variation (CV)	0.70563803
Kurtosis	1935.2832
Mean	18.746592
Median Absolute Deviation (MAD)	6.24
Skewness	29.734918
Sum	33384062
Variance	174.98813
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.2	1271	0.1%
14.4	1254	0.1%
18	1250	0.1%
16.8	1244	0.1%
13.2	1192	0.1%
15.6	1187	0.1%
20.4	1152	0.1%
12	1143	0.1%
21.6	1117	0.1%
10.8	1059	0.1%
Other values (9339)	1768938	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	2	< 0.1%
0	971	0.1%
0.01	12	< 0.1%
0.02	24	< 0.1%
0.03	14	< 0.1%
0.04	9	< 0.1%
0.05	15	< 0.1%
0.06	27	< 0.1%
0.07	20	< 0.1%
0.08	22	< 0.1%

Value	Count	Frequency (%)
999	89	< 0.1%
994.4	1	< 0.1%
991.57	1	< 0.1%
962.83	1	< 0.1%
962.12	1	< 0.1%
942.17	1	< 0.1%
917.87	1	< 0.1%
893.1	1	< 0.1%
886.77	1	< 0.1%
879.55	1	< 0.1%

emp_length
Categorical

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

10	590673
0	259066
2	160692
3	142512
1	117185
Other values (6)	510679

Length

Max length	2
Median length	1
Mean length	1.3316884
Min length	1

Characters and Unicode

Total characters	2371480
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	2
3rd row	10
4th row	3
5th row	4

Common Values

Value	Count	Frequency (%)
10	590673	33.2%
0	259066	14.5%
2	160692	9.0%
3	142512	8.0%
1	117185	6.6%
5	109508	6.1%
4	106030	6.0%
6	80737	4.5%
8	75519	4.2%
7	74368	4.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
10	590673	33.2%
0	259066	14.5%
2	160692	9.0%
3	142512	8.0%
1	117185	6.6%
5	109508	6.1%
4	106030	6.0%
6	80737	4.5%
8	75519	4.2%
7	74368	4.2%

Most occurring characters

Value	Count	Frequency (%)
0	849739	35.8%
1	707858	29.8%
2	160692	6.8%
3	142512	6.0%
5	109508	4.6%
4	106030	4.5%
6	80737	3.4%
8	75519	3.2%
7	74368	3.1%
9	64517	2.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2371480	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	849739	35.8%
1	707858	29.8%
2	160692	6.8%
3	142512	6.0%
5	109508	4.6%
4	106030	4.5%
6	80737	3.4%
8	75519	3.2%
7	74368	3.1%
9	64517	2.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2371480	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	849739	35.8%
1	707858	29.8%
2	160692	6.8%
3	142512	6.0%
5	109508	4.6%
4	106030	4.5%
6	80737	3.4%
8	75519	3.2%
7	74368	3.1%
9	64517	2.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2371480	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	849739	35.8%
1	707858	29.8%
2	160692	6.8%
3	142512	6.0%
5	109508	4.6%
4	106030	4.5%
6	80737	3.4%
8	75519	3.2%
7	74368	3.1%
9	64517	2.7%

emp_title
Text

MISSING

Distinct	355491
Distinct (%)	21.5%
Missing	125407
Missing (%)	7.0%
Memory size	27.2 MiB

Length

Max length	42
Median length	32
Mean length	15.573088
Min length	1

Characters and Unicode

Total characters	25779690
Distinct characters	131
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	269759 ?
Unique (%)	16.3%

Sample

1st row	PROJECT_MANAGER
2nd row	SURGICAL_TECHNICIAN
3rd row	TEAM_LEADERN_CUSTOMER_OPS_&_SYSTEMS
4th row	SYSTEMS_ENGINEER
5th row	ASSISTANT_DIRECTOR_-_HUMAN_RESOURCES

Value	Count	Frequency (%)
teacher	38067	2.3%
manager	37323	2.3%
owner	24645	1.5%
registered_nurse	18555	1.1%
supervisor	18030	1.1%
driver	17899	1.1%
sales	15581	0.9%
rn	14024	0.8%
office_manager	11308	0.7%
project_manager	11219	0.7%
Other values (332086)	1448762	87.5%

Most occurring characters

Value	Count	Frequency (%)
E	2969283	11.5%
R	2430919	9.4%
A	2377113	9.2%
I	1937324	7.5%
N	1865993	7.2%
_	1860173	7.2%
T	1822576	7.1%
S	1713995	6.6%
O	1446120	5.6%
C	1395271	5.4%
Other values (121)	5960923	23.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	25779690	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	2969283	11.5%
R	2430919	9.4%
A	2377113	9.2%
I	1937324	7.5%
N	1865993	7.2%
_	1860173	7.2%
T	1822576	7.1%
S	1713995	6.6%
O	1446120	5.6%
C	1395271	5.4%
Other values (121)	5960923	23.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	25779690	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	2969283	11.5%
R	2430919	9.4%
A	2377113	9.2%
I	1937324	7.5%
N	1865993	7.2%
_	1860173	7.2%
T	1822576	7.1%
S	1713995	6.6%
O	1446120	5.6%
C	1395271	5.4%
Other values (121)	5960923	23.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	25779690	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	2969283	11.5%
R	2430919	9.4%
A	2377113	9.2%
I	1937324	7.5%
N	1865993	7.2%
_	1860173	7.2%
T	1822576	7.1%
S	1713995	6.6%
O	1446120	5.6%
C	1395271	5.4%
Other values (121)	5960923	23.1%

fico_range_high
Real number (ℝ)

Distinct	38
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	701.17756

Minimum	664
Maximum	850
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.2 MiB

Quantile statistics

Minimum	664
5-th percentile	664
Q1	674
median	694
Q3	719
95-th percentile	769
Maximum	850
Range	186
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	32.487435
Coefficient of variation (CV)	0.04633268
Kurtosis	1.5508258
Mean	701.17756
Median Absolute Deviation (MAD)	20
Skewness	1.2599387
Sum	1.2486619 × 10⁹
Variance	1055.4335
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
664	155764	8.7%
674	150673	8.5%
669	150202	8.4%
684	134656	7.6%
679	134595	7.6%
689	118377	6.6%
694	115285	6.5%
699	103553	5.8%
704	96756	5.4%
709	87721	4.9%
Other values (28)	533225	29.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
664	155764	8.7%
669	150202	8.4%
674	150673	8.5%
679	134595	7.6%
684	134656	7.6%
689	118377	6.6%
694	115285	6.5%
699	103553	5.8%
704	96756	5.4%
709	87721	4.9%

Value	Count	Frequency (%)
850	302	< 0.1%
844	398	< 0.1%
839	625	< 0.1%
834	1080	0.1%
829	1612	0.1%
824	2139	0.1%
819	2923	0.2%
814	3466	0.2%
809	4850	0.3%
804	5710	0.3%

fico_range_low
Real number (ℝ)

Distinct	38
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	697.17739

Minimum	660
Maximum	845
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.2 MiB

Quantile statistics

Minimum	660
5-th percentile	660
Q1	670
median	690
Q3	715
95-th percentile	765
Maximum	845
Range	185
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	32.486661
Coefficient of variation (CV)	0.046597411
Kurtosis	1.5492987
Mean	697.17739
Median Absolute Deviation (MAD)	20
Skewness	1.259718
Sum	1.2415384 × 10⁹
Variance	1055.3832
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
660	155764	8.7%
670	150673	8.5%
665	150202	8.4%
680	134656	7.6%
675	134595	7.6%
685	118377	6.6%
690	115285	6.5%
695	103553	5.8%
700	96756	5.4%
705	87721	4.9%
Other values (28)	533225	29.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
660	155764	8.7%
665	150202	8.4%
670	150673	8.5%
675	134595	7.6%
680	134656	7.6%
685	118377	6.6%
690	115285	6.5%
695	103553	5.8%
700	96756	5.4%
705	87721	4.9%

Value	Count	Frequency (%)
845	302	< 0.1%
840	398	< 0.1%
835	625	< 0.1%
830	1080	0.1%
825	1612	0.1%
820	2139	0.1%
815	2923	0.2%
810	3466	0.2%
805	4850	0.3%
800	5710	0.3%

grade
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

B	522184
C	510790
A	328659
D	263837
E	110477
Other values (2)	44860

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1780807
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	B
2nd row	B
3rd row	B
4th row	A
5th row	B

Common Values

Value	Count	Frequency (%)
B	522184	29.3%
C	510790	28.7%
A	328659	18.5%
D	263837	14.8%
E	110477	6.2%
F	34830	2.0%
G	10030	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
b	522184	29.3%
c	510790	28.7%
a	328659	18.5%
d	263837	14.8%
e	110477	6.2%
f	34830	2.0%
g	10030	0.6%

Most occurring characters

Value	Count	Frequency (%)
B	522184	29.3%
C	510790	28.7%
A	328659	18.5%
D	263837	14.8%
E	110477	6.2%
F	34830	2.0%
G	10030	0.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1780807	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
B	522184	29.3%
C	510790	28.7%
A	328659	18.5%
D	263837	14.8%
E	110477	6.2%
F	34830	2.0%
G	10030	0.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1780807	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
B	522184	29.3%
C	510790	28.7%
A	328659	18.5%
D	263837	14.8%
E	110477	6.2%
F	34830	2.0%
G	10030	0.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1780807	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
B	522184	29.3%
C	510790	28.7%
A	328659	18.5%
D	263837	14.8%
E	110477	6.2%
F	34830	2.0%
G	10030	0.6%

home_ownership
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

MORTGAGE	881467
RENT	699117
OWN	198953
ANY	1181
NONE	45

Length

Max length	8
Median length	5
Mean length	5.8675679
Min length	3

Characters and Unicode

Total characters	10449006
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RENT
2nd row	MORTGAGE
3rd row	OWN
4th row	MORTGAGE
5th row	RENT

Common Values

Value	Count	Frequency (%)
MORTGAGE	881467	49.5%
RENT	699117	39.3%
OWN	198953	11.2%
ANY	1181	0.1%
NONE	45	< 0.1%
OTHER	44	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
mortgage	881467	49.5%
rent	699117	39.3%
own	198953	11.2%
any	1181	0.1%
none	45	< 0.1%
other	44	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
G	1762934	16.9%
E	1580673	15.1%
R	1580628	15.1%
T	1580628	15.1%
O	1080509	10.3%
N	899341	8.6%
A	882648	8.4%
M	881467	8.4%
W	198953	1.9%
Y	1181	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10449006	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
G	1762934	16.9%
E	1580673	15.1%
R	1580628	15.1%
T	1580628	15.1%
O	1080509	10.3%
N	899341	8.6%
A	882648	8.4%
M	881467	8.4%
W	198953	1.9%
Y	1181	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10449006	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
G	1762934	16.9%
E	1580673	15.1%
R	1580628	15.1%
T	1580628	15.1%
O	1080509	10.3%
N	899341	8.6%
A	882648	8.4%
M	881467	8.4%
W	198953	1.9%
Y	1181	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10449006	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
G	1762934	16.9%
E	1580673	15.1%
R	1580628	15.1%
T	1580628	15.1%
O	1080509	10.3%
N	899341	8.6%
A	882648	8.4%
M	881467	8.4%
W	198953	1.9%
Y	1181	< 0.1%

inq_last_6mths
Real number (ℝ)

ZEROS

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.60525256

Minimum	0
Maximum	8
Zeros	1058418
Zeros (%)	59.4%
Negative	0
Negative (%)	0.0%
Memory size	27.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	8
Range	8
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.89573932
Coefficient of variation (CV)	1.479943
Kurtosis	3.5699568
Mean	0.60525256
Median Absolute Deviation (MAD)	0
Skewness	1.7598544
Sum	1077838
Variance	0.80234893
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
0	1058418	59.4%
1	476033	26.7%
2	166357	9.3%
3	58072	3.3%
4	15628	0.9%
5	5436	0.3%
6	859	< 0.1%
7	3	< 0.1%
8	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1058418	59.4%
1	476033	26.7%
2	166357	9.3%
3	58072	3.3%
4	15628	0.9%
5	5436	0.3%
6	859	< 0.1%
7	3	< 0.1%
8	1	< 0.1%

Value	Count	Frequency (%)
8	1	< 0.1%
7	3	< 0.1%
6	859	< 0.1%
5	5436	0.3%
4	15628	0.9%
3	58072	3.3%
2	166357	9.3%
1	476033	26.7%
0	1058418	59.4%

installment
Real number (ℝ)

Distinct	88561
Distinct (%)	5.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	444.65469

Minimum	4.93
Maximum	1719.83
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.2 MiB

Quantile statistics

Minimum	4.93
5-th percentile	109.75
Q1	250.29
median	377.04
Q3	591.11
95-th percentile	988.42
Maximum	1719.83
Range	1714.9
Interquartile range (IQR)	340.82

Descriptive statistics

Standard deviation	267.81647
Coefficient of variation (CV)	0.60230214
Kurtosis	0.70629311
Mean	444.65469
Median Absolute Deviation (MAD)	158.01
Skewness	1.0098912
Sum	7.9184418 × 10⁸
Variance	71725.661
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
301.15	3860	0.2%
332.1	3375	0.2%
327.34	3280	0.2%
361.38	3151	0.2%
602.3	2739	0.2%
451.73	2736	0.2%
329.72	2560	0.1%
318.79	2281	0.1%
312.86	2181	0.1%
392.81	2168	0.1%
Other values (88551)	1752476	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4.93	1	< 0.1%
7.61	1	< 0.1%
14.01	1	< 0.1%
14.77	1	< 0.1%
19.4	1	< 0.1%
20.11	1	< 0.1%
23.26	1	< 0.1%
23.36	1	< 0.1%
25.81	1	< 0.1%
25.86	1	< 0.1%

Value	Count	Frequency (%)
1719.83	2	< 0.1%
1717.63	1	< 0.1%
1715.42	2	< 0.1%
1714.54	5	< 0.1%
1691.28	2	< 0.1%
1676.23	2	< 0.1%
1671.88	2	< 0.1%
1670.15	1	< 0.1%
1664.57	1	< 0.1%
1647.03	1	< 0.1%

int_rate
Real number (ℝ)

Distinct	395
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.13186416

Minimum	0.0531
Maximum	0.3099
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.2 MiB

Quantile statistics

Minimum	0.0531
5-th percentile	0.0649
Q1	0.0949
median	0.1269
Q3	0.1599
95-th percentile	0.2239
Maximum	0.3099
Range	0.2568
Interquartile range (IQR)	0.065

Descriptive statistics

Standard deviation	0.04851914
Coefficient of variation (CV)	0.3679479
Kurtosis	0.55136545
Mean	0.13186416
Median Absolute Deviation (MAD)	0.0325
Skewness	0.75768475
Sum	234824.62
Variance	0.002354107
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.1199	41915	2.4%
0.0532	41635	2.3%
0.1099	41298	2.3%
0.1399	36830	2.1%
0.1149	29448	1.7%
0.1699	28174	1.6%
0.1299	27678	1.6%
0.0789	27379	1.5%
0.0917	26922	1.5%
0.1561	24259	1.4%
Other values (385)	1455269	81.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0531	3294	0.2%
0.0532	41635	2.3%
0.0593	1809	0.1%
0.06	600	< 0.1%
0.0603	9250	0.5%
0.0607	2223	0.1%
0.0608	2937	0.2%
0.0611	3834	0.2%
0.0619	1314	0.1%
0.0624	7456	0.4%

Value	Count	Frequency (%)
0.3099	663	< 0.1%
0.3094	571	< 0.1%
0.3089	540	< 0.1%
0.3084	611	< 0.1%
0.3079	1159	0.1%
0.3075	750	< 0.1%
0.3074	392	< 0.1%
0.3065	687	< 0.1%
0.3049	440	< 0.1%
0.3017	843	< 0.1%

issue_d
Date

Distinct	98
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	27.2 MiB

Minimum	2012-08-01 00:00:00
Maximum	2020-09-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

last_fico_range_high
Real number (ℝ)

Distinct	72
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	678.57609

Minimum	0
Maximum	850
Zeros	178
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	27.2 MiB

Quantile statistics

Minimum	0
5-th percentile	519
Q1	624
median	694
Q3	739
95-th percentile	799
Maximum	850
Range	850
Interquartile range (IQR)	115

Descriptive statistics

Standard deviation	82.460517
Coefficient of variation (CV)	0.12151993
Kurtosis	-0.10653194
Mean	678.57609
Median Absolute Deviation (MAD)	50
Skewness	-0.55279513
Sum	1.208413 × 10⁹
Variance	6799.7369
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
709	54374	3.1%
694	53856	3.0%
714	53632	3.0%
699	53504	3.0%
704	53436	3.0%
719	53034	3.0%
724	51560	2.9%
684	49031	2.8%
689	48530	2.7%
499	47554	2.7%
Other values (62)	1262296	70.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	178	< 0.1%
499	47554	2.7%
504	10136	0.6%
509	10827	0.6%
514	12227	0.7%
519	12526	0.7%
524	14127	0.8%
529	13923	0.8%
534	15741	0.9%
539	15800	0.9%

Value	Count	Frequency (%)
850	364	< 0.1%
844	869	< 0.1%
839	1644	0.1%
834	3251	0.2%
829	5387	0.3%
824	6942	0.4%
819	10090	0.6%
814	11704	0.7%
809	14522	0.8%
804	17142	1.0%

last_fico_range_low
Real number (ℝ)

ZEROS

Distinct	71
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	661.35799

Minimum	0
Maximum	845
Zeros	47732
Zeros (%)	2.7%
Negative	0
Negative (%)	0.0%
Memory size	27.2 MiB

Quantile statistics

Minimum	0
5-th percentile	515
Q1	620
median	690
Q3	735
95-th percentile	795
Maximum	845
Range	845
Interquartile range (IQR)	115

Descriptive statistics

Standard deviation	133.84636
Coefficient of variation (CV)	0.20238111
Kurtosis	13.241018
Mean	661.35799
Median Absolute Deviation (MAD)	50
Skewness	-3.1858893
Sum	1.1777509 × 10⁹
Variance	17914.848
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
705	54374	3.1%
690	53856	3.0%
710	53632	3.0%
695	53504	3.0%
700	53436	3.0%
715	53034	3.0%
720	51560	2.9%
680	49031	2.8%
685	48530	2.7%
0	47732	2.7%
Other values (61)	1262118	70.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	47732	2.7%
500	10136	0.6%
505	10827	0.6%
510	12227	0.7%
515	12526	0.7%
520	14127	0.8%
525	13923	0.8%
530	15741	0.9%
535	15800	0.9%
540	17649	1.0%

Value	Count	Frequency (%)
845	364	< 0.1%
840	869	< 0.1%
835	1644	0.1%
830	3251	0.2%
825	5387	0.3%
820	6942	0.4%
815	10090	0.6%
810	11704	0.7%
805	14522	0.8%
800	17142	1.0%

loan_amnt
Real number (ℝ)

Distinct	1561
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14736.404

Minimum	1000
Maximum	40000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.2 MiB

Quantile statistics

Minimum	1000
5-th percentile	3200
Q1	8000
median	12100
Q3	20000
95-th percentile	35000
Maximum	40000
Range	39000
Interquartile range (IQR)	12000

Descriptive statistics

Standard deviation	9000.6551
Coefficient of variation (CV)	0.61077689
Kurtosis	-0.08851783
Mean	14736.404
Median Absolute Deviation (MAD)	5900
Skewness	0.78861326
Sum	2.6242691 × 10¹⁰
Variance	81011792
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	139718	7.8%
20000	97500	5.5%
15000	94562	5.3%
12000	94452	5.3%
35000	67362	3.8%
5000	66407	3.7%
8000	61776	3.5%
6000	58295	3.3%
16000	50325	2.8%
25000	48111	2.7%
Other values (1551)	1002299	56.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000	7850	0.4%
1025	30	< 0.1%
1050	45	< 0.1%
1075	22	< 0.1%
1100	225	< 0.1%
1125	38	< 0.1%
1150	33	< 0.1%
1175	15	< 0.1%
1200	3099	0.2%
1225	16	< 0.1%

Value	Count	Frequency (%)
40000	18659	1.0%
39975	10	< 0.1%
39950	5	< 0.1%
39925	6	< 0.1%
39900	15	< 0.1%
39875	5	< 0.1%
39850	4	< 0.1%
39825	10	< 0.1%
39800	9	< 0.1%
39775	9	< 0.1%

loan_status
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

Fully Paid	1422806
Non-Performing	358001

Length

Max length	14
Median length	10
Mean length	10.804132
Min length	10

Characters and Unicode

Total characters	19240074
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Fully Paid
2nd row	Fully Paid
3rd row	Fully Paid
4th row	Fully Paid
5th row	Fully Paid

Common Values

Value	Count	Frequency (%)
Fully Paid	1422806	79.9%
Non-Performing	358001	20.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
fully	1422806	44.4%
paid	1422806	44.4%
non-performing	358001	11.2%

Most occurring characters

Value	Count	Frequency (%)
l	2845612	14.8%
P	1780807	9.3%
i	1780807	9.3%
F	1422806	7.4%
y	1422806	7.4%
	1422806	7.4%
a	1422806	7.4%
d	1422806	7.4%
u	1422806	7.4%
r	716002	3.7%
Other values (8)	3580010	18.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	19240074	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	2845612	14.8%
P	1780807	9.3%
i	1780807	9.3%
F	1422806	7.4%
y	1422806	7.4%
	1422806	7.4%
a	1422806	7.4%
d	1422806	7.4%
u	1422806	7.4%
r	716002	3.7%
Other values (8)	3580010	18.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	19240074	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	2845612	14.8%
P	1780807	9.3%
i	1780807	9.3%
F	1422806	7.4%
y	1422806	7.4%
	1422806	7.4%
a	1422806	7.4%
d	1422806	7.4%
u	1422806	7.4%
r	716002	3.7%
Other values (8)	3580010	18.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	19240074	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	2845612	14.8%
P	1780807	9.3%
i	1780807	9.3%
F	1422806	7.4%
y	1422806	7.4%
	1422806	7.4%
a	1422806	7.4%
d	1422806	7.4%
u	1422806	7.4%
r	716002	3.7%
Other values (8)	3580010	18.6%

purpose
Categorical

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

debt_consolidation	1023751
credit_card	402392
home_improvement	117589
other	105466
major_purchase	38262
Other values (9)	93347

Length

Max length	18
Median length	18
Mean length	14.876841
Min length	3

Characters and Unicode

Total characters	26492782
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	debt_consolidation
2nd row	home_improvement
3rd row	debt_consolidation
4th row	debt_consolidation
5th row	debt_consolidation

Common Values

Value	Count	Frequency (%)
debt_consolidation	1023751	57.5%
credit_card	402392	22.6%
home_improvement	117589	6.6%
other	105466	5.9%
major_purchase	38262	2.1%
medical	21100	1.2%
car	17845	1.0%
small_business	17557	1.0%
vacation	12441	0.7%
moving	12105	0.7%
Other values (4)	12299	0.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
debt_consolidation	1023751	57.5%
credit_card	402392	22.6%
home_improvement	117589	6.6%
other	105466	5.9%
major_purchase	38262	2.1%
medical	21100	1.2%
car	17845	1.0%
small_business	17557	1.0%
vacation	12441	0.7%
moving	12105	0.7%
Other values (4)	12299	0.7%

Most occurring characters

Value	Count	Frequency (%)
o	3485038	13.2%
d	2875120	10.9%
t	2685392	10.1%
i	2631554	9.9%
n	2210262	8.3%
e	1977994	7.5%
c	1918185	7.2%
_	1600651	6.0%
a	1585155	6.0%
s	1142572	4.3%
Other values (12)	4380859	16.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	26492782	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	3485038	13.2%
d	2875120	10.9%
t	2685392	10.1%
i	2631554	9.9%
n	2210262	8.3%
e	1977994	7.5%
c	1918185	7.2%
_	1600651	6.0%
a	1585155	6.0%
s	1142572	4.3%
Other values (12)	4380859	16.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	26492782	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	3485038	13.2%
d	2875120	10.9%
t	2685392	10.1%
i	2631554	9.9%
n	2210262	8.3%
e	1977994	7.5%
c	1918185	7.2%
_	1600651	6.0%
a	1585155	6.0%
s	1142572	4.3%
Other values (12)	4380859	16.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	26492782	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	3485038	13.2%
d	2875120	10.9%
t	2685392	10.1%
i	2631554	9.9%
n	2210262	8.3%
e	1977994	7.5%
c	1918185	7.2%
_	1600651	6.0%
a	1585155	6.0%
s	1142572	4.3%
Other values (12)	4380859	16.5%

revol_bal
Real number (ℝ)

Distinct	93490
Distinct (%)	5.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16482.243

Minimum	0
Maximum	2904836
Zeros	6779
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	27.2 MiB

Quantile statistics

Minimum	0
5-th percentile	1705
Q1	5969
median	11210
Q3	19963
95-th percentile	44347
Maximum	2904836
Range	2904836
Interquartile range (IQR)	13994

Descriptive statistics

Standard deviation	22665.016
Coefficient of variation (CV)	1.3751172
Kurtosis	575.91154
Mean	16482.243
Median Absolute Deviation (MAD)	6231
Skewness	12.568435
Sum	2.9351693 × 10¹⁰
Variance	5.1370297 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6779	0.4%
8	174	< 0.1%
6312	137	< 0.1%
5453	132	< 0.1%
10	128	< 0.1%
2	128	< 0.1%
5570	128	< 0.1%
5849	127	< 0.1%
5232	127	< 0.1%
4777	127	< 0.1%
Other values (93480)	1772820	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6779	0.4%
1	94	< 0.1%
2	128	< 0.1%
3	119	< 0.1%
4	113	< 0.1%
5	107	< 0.1%
6	117	< 0.1%
7	97	< 0.1%
8	174	< 0.1%
9	116	< 0.1%

Value	Count	Frequency (%)
2904836	1	< 0.1%
2568995	1	< 0.1%
2560703	1	< 0.1%
1746716	1	< 0.1%
1743266	1	< 0.1%
1696796	1	< 0.1%
1470945	1	< 0.1%
1392002	1	< 0.1%
1298783	1	< 0.1%
1190046	1	< 0.1%

revol_util
Real number (ℝ)

Distinct	1305
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.50422159

Minimum	0
Maximum	3.666
Zeros	8251
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	27.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0.096
Q1	0.317
median	0.504
Q3	0.693
95-th percentile	0.909
Maximum	3.666
Range	3.666
Interquartile range (IQR)	0.376

Descriptive statistics

Standard deviation	0.24612087
Coefficient of variation (CV)	0.48812045
Kurtosis	-0.80754693
Mean	0.50422159
Median Absolute Deviation (MAD)	0.188
Skewness	-0.0079713773
Sum	897921.34
Variance	0.060575483
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8251	0.5%
0.57	3465	0.2%
0.48	3459	0.2%
0.59	3438	0.2%
0.53	3410	0.2%
0.58	3409	0.2%
0.61	3388	0.2%
0.55	3359	0.2%
0.54	3341	0.2%
0.6	3325	0.2%
Other values (1295)	1741962	97.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8251	0.5%
0.001	1374	0.1%
0.002	1126	0.1%
0.003	1036	0.1%
0.004	896	0.1%
0.005	857	< 0.1%
0.006	793	< 0.1%
0.007	765	< 0.1%
0.008	746	< 0.1%
0.009	733	< 0.1%

Value	Count	Frequency (%)
3.666	1	< 0.1%
1.93	1	< 0.1%
1.846	1	< 0.1%
1.828	1	< 0.1%
1.803	1	< 0.1%
1.777	1	< 0.1%
1.72	1	< 0.1%
1.669	1	< 0.1%
1.658	1	< 0.1%
1.62	1	< 0.1%

sub_grade
Categorical

Distinct	35
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

C1	114130
B5	111327
B4	110770
B3	103688
C2	103646
Other values (30)	1237246

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	3561614
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	B2
2nd row	B2
3rd row	B2
4th row	A3
5th row	B4

Common Values

Value	Count	Frequency (%)
C1	114130	6.4%
B5	111327	6.3%
B4	110770	6.2%
B3	103688	5.8%
C2	103646	5.8%
C3	100634	5.7%
C4	100110	5.6%
B1	98344	5.5%
B2	98055	5.5%
C5	92270	5.2%
Other values (25)	747833	42.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
c1	114130	6.4%
b5	111327	6.3%
b4	110770	6.2%
b3	103688	5.8%
c2	103646	5.8%
c3	100634	5.7%
c4	100110	5.6%
b1	98344	5.5%
b2	98055	5.5%
c5	92270	5.2%
Other values (25)	747833	42.0%

Most occurring characters

Value	Count	Frequency (%)
B	522184	14.7%
C	510790	14.3%
1	386678	10.9%
4	353356	9.9%
2	350333	9.8%
5	350113	9.8%
3	340327	9.6%
A	328659	9.2%
D	263837	7.4%
E	110477	3.1%
Other values (2)	44860	1.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3561614	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
B	522184	14.7%
C	510790	14.3%
1	386678	10.9%
4	353356	9.9%
2	350333	9.8%
5	350113	9.8%
3	340327	9.6%
A	328659	9.2%
D	263837	7.4%
E	110477	3.1%
Other values (2)	44860	1.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3561614	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
B	522184	14.7%
C	510790	14.3%
1	386678	10.9%
4	353356	9.9%
2	350333	9.8%
5	350113	9.8%
3	340327	9.6%
A	328659	9.2%
D	263837	7.4%
E	110477	3.1%
Other values (2)	44860	1.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3561614	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
B	522184	14.7%
C	510790	14.3%
1	386678	10.9%
4	353356	9.9%
2	350333	9.8%
5	350113	9.8%
3	340327	9.6%
A	328659	9.2%
D	263837	7.4%
E	110477	3.1%
Other values (2)	44860	1.3%

term
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

36	1330275
60	450532

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	3561614
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	36
2nd row	36
3rd row	36
4th row	36
5th row	36

Common Values

Value	Count	Frequency (%)
36	1330275	74.7%
60	450532	25.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
36	1330275	74.7%
60	450532	25.3%

Most occurring characters

Value	Count	Frequency (%)
6	1780807	50.0%
3	1330275	37.4%
0	450532	12.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3561614	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
6	1780807	50.0%
3	1330275	37.4%
0	450532	12.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3561614	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
6	1780807	50.0%
3	1330275	37.4%
0	450532	12.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3561614	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
6	1780807	50.0%
3	1330275	37.4%
0	450532	12.6%

verification_status
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

Source Verified	711992
Not Verified	558561
Verified	510254

Length

Max length	15
Median length	12
Mean length	12.053324
Min length	8

Characters and Unicode

Total characters	21464644
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Not Verified
2nd row	Source Verified
3rd row	Verified
4th row	Not Verified
5th row	Not Verified

Common Values

Value	Count	Frequency (%)
Source Verified	711992	40.0%
Not Verified	558561	31.4%
Verified	510254	28.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
verified	1780807	58.4%
source	711992	23.3%
not	558561	18.3%

Most occurring characters

Value	Count	Frequency (%)
e	4273606	19.9%
i	3561614	16.6%
r	2492799	11.6%
V	1780807	8.3%
f	1780807	8.3%
d	1780807	8.3%
o	1270553	5.9%
	1270553	5.9%
S	711992	3.3%
u	711992	3.3%
Other values (3)	1829114	8.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21464644	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	4273606	19.9%
i	3561614	16.6%
r	2492799	11.6%
V	1780807	8.3%
f	1780807	8.3%
d	1780807	8.3%
o	1270553	5.9%
	1270553	5.9%
S	711992	3.3%
u	711992	3.3%
Other values (3)	1829114	8.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21464644	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	4273606	19.9%
i	3561614	16.6%
r	2492799	11.6%
V	1780807	8.3%
f	1780807	8.3%
d	1780807	8.3%
o	1270553	5.9%
	1270553	5.9%
S	711992	3.3%
u	711992	3.3%
Other values (3)	1829114	8.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21464644	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	4273606	19.9%
i	3561614	16.6%
r	2492799	11.6%
V	1780807	8.3%
f	1780807	8.3%
d	1780807	8.3%
o	1270553	5.9%
	1270553	5.9%
S	711992	3.3%
u	711992	3.3%
Other values (3)	1829114	8.5%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	addr_state	annual_inc	application_type	avg_cur_bal	bc_util	delinq_2yrs	dti	emp_length	emp_title	fico_range_high	fico_range_low	grade	home_ownership	inq_last_6mths	installment	int_rate	issue_d	last_fico_range_high	last_fico_range_low	loan_amnt	loan_status	purpose	revol_bal	revol_util	sub_grade	term	verification_status
42536	NC	60000.0	Individual	476.0	15.9	0.0	4.62	4	PROJECT_MANAGER	724.0	720.0	B	RENT	1.0	392.81	0.1099	2013-12-01	569.0	565.0	12000.0	Fully Paid	debt_consolidation	7137.0	0.240	B2	36	Not Verified
42537	TX	39600.0	Individual	1379.0	16.1	0.0	2.49	2	SURGICAL_TECHNICIAN	759.0	755.0	B	MORTGAGE	2.0	157.13	0.1099	2013-12-01	534.0	530.0	4800.0	Fully Paid	home_improvement	4136.0	0.161	B2	36	Source Verified
42538	MI	55000.0	Individual	9570.0	53.9	0.0	22.87	10	TEAM_LEADERN_CUSTOMER_OPS_&_SYSTEMS	734.0	730.0	B	OWN	0.0	885.46	0.1099	2013-12-01	834.0	830.0	27050.0	Fully Paid	debt_consolidation	36638.0	0.612	B2	36	Verified
42539	TX	96500.0	Individual	11783.0	83.5	0.0	12.61	3	SYSTEMS_ENGINEER	709.0	705.0	A	MORTGAGE	0.0	373.94	0.0762	2013-12-01	809.0	805.0	12000.0	Fully Paid	debt_consolidation	13248.0	0.557	A3	36	Not Verified
42540	NC	88000.0	Individual	2945.0	87.7	1.0	10.02	4	ASSISTANT_DIRECTOR_-_HUMAN_RESOURCES	674.0	670.0	B	RENT	0.0	470.71	0.1285	2013-12-01	569.0	565.0	14000.0	Fully Paid	debt_consolidation	3686.0	0.819	B4	36	Not Verified
42541	CT	105000.0	Individual	26765.0	25.0	0.0	14.05	10	MANAGER_INFORMATION_DELIVERY	764.0	760.0	A	MORTGAGE	1.0	368.45	0.0662	2013-12-01	779.0	775.0	12000.0	Fully Paid	debt_consolidation	13168.0	0.216	A2	36	Not Verified
42542	FL	63000.0	Individual	38927.0	79.1	0.0	16.51	2	AIRCRAFT_MAINTENANCE_ENGINEER	674.0	670.0	A	MORTGAGE	0.0	476.30	0.0890	2013-12-01	749.0	745.0	15000.0	Fully Paid	debt_consolidation	11431.0	0.742	A5	36	Not Verified
42543	CA	28000.0	Individual	1440.0	96.0	0.0	8.40	3	SPECIAL_ORDER_FULFILLMENT_CLERK	664.0	660.0	C	RENT	0.0	266.34	0.1624	2013-12-01	634.0	630.0	7550.0	Fully Paid	debt_consolidation	5759.0	0.720	C5	36	Not Verified
42544	CA	325000.0	Individual	53306.0	67.1	0.0	18.55	5	AREA_SALES_MANAGER	749.0	745.0	A	MORTGAGE	1.0	872.52	0.0762	2013-12-01	789.0	785.0	28000.0	Fully Paid	debt_consolidation	29581.0	0.546	A3	36	Source Verified
42545	CO	130000.0	Individual	36362.0	93.0	0.0	13.03	10	LTC	719.0	715.0	B	MORTGAGE	1.0	398.52	0.1199	2013-12-01	714.0	710.0	12000.0	Fully Paid	debt_consolidation	10805.0	0.670	B3	36	Source Verified

	addr_state	annual_inc	application_type	avg_cur_bal	bc_util	chargeoff_within_12_mths	delinq_2yrs	dti	emp_length	emp_title	fico_range_high	fico_range_low	grade	home_ownership	inq_last_6mths	installment	int_rate	issue_d	last_fico_range_high	last_fico_range_low	loan_amnt	loan_status	purpose	revol_bal	revol_util	sub_grade	term	verification_status
2925483	FL	32000.0	Joint App	2331.0	52.9	0.0	0.0	70.92	4	SALES_MANAGER	709.0	705.0	C	MORTGAGE	1.0	683.94	0.1399	2017-04-01	639.0	635.0	29400.0	Fully Paid	debt_consolidation	12264.0	0.461	C3	60	Source Verified
2925484	MD	180000.0	Individual	63816.0	68.0	0.0	0.0	10.41	5	BRANCH_MANAGER	679.0	675.0	E	OWN	4.0	1037.38	0.2549	2017-04-01	744.0	740.0	35000.0	Fully Paid	debt_consolidation	31233.0	0.580	E4	60	Source Verified
2925485	CA	64500.0	Individual	11056.0	67.3	0.0	0.0	9.66	10	FOREMAN	664.0	660.0	F	MORTGAGE	3.0	378.65	0.2869	2017-04-01	644.0	640.0	12000.0	Fully Paid	home_improvement	16478.0	0.513	F1	60	Not Verified
2925486	IL	100000.0	Individual	28408.0	14.2	0.0	0.0	8.32	0	INDUSTRIAL_ENGINEER	689.0	685.0	C	MORTGAGE	1.0	814.21	0.1399	2017-04-01	774.0	770.0	35000.0	Fully Paid	debt_consolidation	3162.0	0.142	C3	60	Source Verified
2925487	CA	53000.0	Individual	4113.0	92.1	0.0	0.0	24.65	0	NaN	664.0	660.0	E	RENT	0.0	538.40	0.2274	2017-04-01	584.0	580.0	19200.0	Non-Performing	debt_consolidation	23058.0	0.769	E1	60	Source Verified
2925488	CO	107000.0	Individual	5528.0	26.0	1.0	3.0	11.65	0	SENIOR_ESCROW_OFFICER	674.0	670.0	E	RENT	1.0	690.30	0.2399	2017-04-01	504.0	500.0	24000.0	Non-Performing	other	9688.0	0.249	E2	60	Source Verified
2925489	PA	65000.0	Individual	3724.0	24.6	0.0	1.0	19.55	10	RN	729.0	725.0	A	MORTGAGE	0.0	313.32	0.0799	2017-04-01	769.0	765.0	10000.0	Fully Paid	debt_consolidation	9751.0	0.157	A5	36	Source Verified
2925490	VA	37000.0	Individual	1021.0	66.1	0.0	0.0	20.56	8	SALES_ASSOCIATE	709.0	705.0	D	RENT	1.0	358.26	0.1699	2017-04-01	539.0	535.0	10050.0	Non-Performing	debt_consolidation	14300.0	0.470	D1	36	Not Verified
2925491	NY	41000.0	Individual	3275.0	5.5	0.0	1.0	19.99	5	CONTACT_INPUT	674.0	670.0	B	RENT	0.0	197.69	0.1144	2017-04-01	764.0	760.0	6000.0	Fully Paid	credit_card	1356.0	0.101	B4	36	Source Verified
2925492	TX	105700.0	Individual	19955.0	80.6	0.0	1.0	27.26	4	ASSISTANT_MANAGER	699.0	695.0	E	MORTGAGE	0.0	889.18	0.2549	2017-04-01	579.0	575.0	30000.0	Non-Performing	debt_consolidation	15252.0	0.726	E4	60	Verified

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories